package kr.co.kiso.usr.am.gr.dao;

import java.util.List;
import java.util.Map;

import kr.co.kiso.usr.am.gr.vo.AMGRVo;
import kr.co.kiso.usr.common.BaseDao;

import org.springframework.stereotype.Repository;

@Repository
public class AMGRDao extends BaseDao{

	
	@SuppressWarnings("unchecked")
	public int amgr010Q_cnt(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr010Q_cnt", vo);
	}
	@SuppressWarnings("unchecked")
	public List amgr010Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr010Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr020Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr020Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr021Q() throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr021Q");
	}
	
	@SuppressWarnings("unchecked")
	public List amgr022Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr022Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public void amgr020T(AMGRVo vo) throws Exception {
		getSqlMapClientTemplate().insert("amgr.amgr020T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public Map amgr030Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr030Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr030T(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().update("amgr.amgr030T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr040T(AMGRVo vo) throws Exception {
		return  getSqlMapClientTemplate().update("amgr.amgr040T", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int amgr050Q_cnt(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr050Q_cnt", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr050Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr050Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr060Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr060Q", vo);
	}
	@SuppressWarnings("unchecked")
	public List amgr061Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr061Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr062Q(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr062Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr063Q(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr063Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public void amgr060T(AMGRVo vo) throws Exception {
		getSqlMapClientTemplate().insert("amgr.amgr060T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public void amgr061T(AMGRVo vo) throws Exception {
		getSqlMapClientTemplate().insert("amgr.amgr061T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr070Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr070Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public Map amgr071Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr071Q", vo);
	}
	
	
	
	@SuppressWarnings("unchecked")
	public int amgr070T(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().delete("amgr.amgr070T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr071T(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().update("amgr.amgr071T", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int amgr100Q_cnt(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr100Q_cnt", vo);
	}
	@SuppressWarnings("unchecked")
	public List amgr100Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr100Q", vo);
	}
	@SuppressWarnings("unchecked")
	public int amgr111Q(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr111Q", vo);
	}
	@SuppressWarnings("unchecked")
	public int amgr1112(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr112Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public void amgr110T(AMGRVo vo) throws Exception {
		getSqlMapClientTemplate().insert("amgr.amgr110T", vo);
	}
	@SuppressWarnings("unchecked")
	public Map amgr120Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr120Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr121Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr121Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr120T(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().update("amgr.amgr120T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr150Q_cnt(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr150Q_cnt", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr150Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr150Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr160Q(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject("amgr.amgr160Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public void amgr160T(AMGRVo vo) throws Exception {
		getSqlMapClientTemplate().insert("amgr.amgr160T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public Map amgr170Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr170Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr171Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr171Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int amgr170T(AMGRVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().update("amgr.amgr170T", vo);
	}

	@SuppressWarnings("unchecked")
	public Map amgr180Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr180Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public Map amgr181Q(AMGRVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("amgr.amgr181Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public List amgr190Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr190Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List amgr200Q(AMGRVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("amgr.amgr200Q", vo);
	}
	
}



